﻿CREATE TABLE [dbo].[Task] (
    [Id]                       INT           IDENTITY (1, 1) NOT NULL,
    [IsDeleted]                BIT           NOT NULL,
    [CreatedDate]              DATETIME      NOT NULL,
    [ModifiedDate]             DATETIME      NOT NULL,
    [UserId]                   INT           NOT NULL,
    [BusinessId]               INT           NOT NULL,
    [ParameterContainerNumber] VARCHAR (32)  NULL,
    [ParameterConveyance]      VARCHAR (32)  NULL,
    [ParameterVoyageNumber]    VARCHAR (16)  NULL,
    [ParameterDock]            NVARCHAR (32) NULL,
    [RunningFrequency]         INT           NOT NULL,
    [RunningDuration]          INT           NULL,
    [RunningStartTime]         DATETIME      NULL,
    [TaskStateId]              INT           NOT NULL,
    [ResultMessage]            NVARCHAR (64) NULL,
    [WarningMessage]           NVARCHAR (64) NULL
);



